﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="dataImport.aspx.cs" Inherits="adm_dataImport" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body style="font-family:Courier New;font-size:12px;">
    <form id="form1" metgod="post" runat="server" enctype="multipart/form-data">
    <br /><br />
    <input type="hidden" id="file_type_hdn" name="file_type_hdn" runat="server" />
    <div id="div_step_0" runat="server" style="text-align:center;" visible="false">
        <input type="hidden" name="sender" value="div_step_0" />
        <table width="600px" border="0px" style="border:1px solid black;">
            <tr>
                <td style="text-align:center;">
                    WELCOME TO THE DATA IMPORT WIZARD.<br /><br />
                    PLEASE SELECT THE DATA FILE TO IMPORT.<br /><br />
                    REQUIREMENTS:<br /><br />
                </td>
            </tr>
            <tr>
                <td style="text-align:left;">
                    <ul>
                        <li>THE DATA FILE SHOULD BE A "TAB" DELIMITED TEXT FILE</li>
                    </ul>
                    SPECIFIC FOR FLAT DATA FILES:
                    <ul>
                        <li>THE DATA FILE SHOULD CONTAIN THE FIELD NAMES IN THE FIRST ROW</li>
                        <li>THE NUMBER OF VALUES IN A ROW SHOULD BE EQUAL TO THE NUMBER OF COLUMNS</li>
                        <li>THE COLUMN LIST SHOULD CONTAIN THE MANDATORY FIELDS [AY], [YIL] AND [BAYII]</li>
                        <li>THE VALUES SHOULD BE COMPATIBLE WITH THE COLUMN DATA TYPES IN THE DATABASE</li>
                    </ul>
                    SPECIFIC FOR VERBATIM FILES:
                    <ul>
                        <li>THE DATA FILE SHOULD CONTAIN (IN ORDER) THE FOLLOWING COLUMNS:</li>
                        <li>MONTH</li>
                        <li>YEAR</li>
                        <li>DEALER CODE</li>
                        <li>IID (Interviewee Identifier, same as the one in the flat data)</li>
                        <li>QUESTION CODE</li>
                        <li>CONTENTS</li>
                        <li>MAKE (Renault, Dacia or QVO)</li>
                        <li>INTERVIEWEE (The name of the person responded to the questions)</li>
                        <li>SATISFACTION (The satisfaction level of the interviewee if a related satisfactory question exists)</li>
                    </ul>
                </td>
            </tr>
            <tr>
                <td align="center">
                    <input type="radio" name="file_type" value="flat" checked="checked"/> FLAT DATA FILE<br />
                    <input type="radio" name="file_type" value="verbatim"/> VERBATIM FILE
                </td>
            </tr>
            <tr>
                <td>
                    <input type="file" name="data_file" style="width:400px;font-family:Courier New;font-size:12px;" />
                    <br /><br />
                </td>
            </tr>
        </table>
    </div>
    
    <div id="div_step_1" runat="server" style="text-align:center;" visible="false">
        <input type="hidden" name="sender" value="div_step_1" />
        <table width="800px" border="0px" style="border:1px solid black;">
            <asp:Literal id="div_step_1_html" runat="server" />
        </table>
    </div>

    <div id="div_exception" runat="server" style="text-align:center;" visible="false">
        <table width="600px" border="0px" style="border:1px solid black;">
            <tr>
                <td style="font-size:16px;background-color:#802020;color:#fff;">
                    <br />
                    <br />
                    ERROR!
                    <br />
                    <br />
                    <asp:Literal id="div_exception_html" runat="server" />
                    <br />
                    <br />
                    <br />
                    <font style="cursor:hand;text-decoration:underline;" onclick="javascript:history.back();">GO BACK</a>
                    <br />
                    <br />
                </td>
            </tr>
        </table>
        <br />
        <br />
    </div>
    
    <div style="text-align:center;">
        <br /><br />
        <input id="submitButton" type="submit" style="font-family:Courier New;font-size:12px;" value="Continue" />
    </div>

    </form>
</body>
</html>
